﻿using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Configuration;

namespace WebService1
{
    /// <summary>
    /// Summary description for Service1
    /// </summary>
    [WebService(Namespace = "http://localhost/teste")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    // [System.Web.Script.Services.ScriptService]
    public class Service1 : System.Web.Services.WebService
    {
        [WebMethod]
        public DataSet GetRecursos()
        {
            SqlDataReader myReader = null;

            String stringCon = ConfigurationSettings.AppSettings["ConnectionString"];
            SqlConnection sqlCon = new SqlConnection(stringCon);
            SqlCommand sqlCmd = new SqlCommand("SELECT * FROM RECURSO", sqlCon);
            sqlCon.Open();

            myReader = sqlCmd.ExecuteReader();

            DataSet servAns = Commons.convertDataReaderToDataSet(myReader);

            sqlCon.Close();

            return servAns;
        }

        [WebMethod]
        public DataSet VisualizarDisponibilidadeRecurso(int idRecurso) 
        {
            //bool isDisponivel = false;

            SqlDataReader myReader = null;

            String stringCon = ConfigurationSettings.AppSettings["ConnectionString"];
            SqlConnection sqlCon = new SqlConnection(stringCon);
            SqlCommand sqlCmd = new SqlCommand("SELECT Quantidade FROM RECURSO WHERE id = " + idRecurso, sqlCon);
            

            sqlCon.Open();

            myReader = sqlCmd.ExecuteReader();

            DataSet servAns = Commons.convertDataReaderToDataSet(myReader);

            sqlCon.Close();

            return servAns;

            
            //return isDisponivel;        
        }
    }
}
